Bshop 接口
/user/payment/add
method
post
request
name M string
telephone M string
bill_receiver O string 新增
bill_address O string 新增
response
{ code: 0, msg: "OK", data: null }
MA 接口
/custommanage/edit/S(\d+)$
method
post
reuqest
status M string
新增两个可选值：modifyBillReveiver, modifyBillAddress
bill_receiver O string 新增 当且仅当 status 为 "modifyBillReceiver"
bill_address O string 新增 当且仅当 status 为 "modifyBillAddress"
....
response
{ code: 0, msg: "OK", data: null }
method
get
request
不变
response
{
data: {
data: {
bill_receiver: "AAA", M string or null 【新增】
bill_address: "BBB" M string or null 【新增】
}
}
}
station 接口
/station/transport/get_order_by_id_new
method
post
reuqest
response
[
{
id: "PL2153100",
tax_number: 99999, [新增，M int or null]
bill_receiver: "string", [新增，M str or null]
bill_address: "string", [新增，M str or null]
address_route_name: "route A" [新增，M str or null]
pay_method: { [新增，M object ]
pay_method: 1 1:日结，2：周结，3：月结，4：自定义
begin_day: 1 起始日,周一的话就是1，每月2号就是2
settle_day: 2 结算日,周一的话就是1，每月2号就是2
cycle_length: 13 自定义周期长度13天就是13
}
......
},
......
]
数据库
management.tbl_user
增加两列 （在 devhost 上测试，这张一百万条数据的表 每增加一列需要 2.6 秒）
USE management;
ALTER TABLE `tbl_user`
ADD COLUMN `bill_receiver` varchar(20) DEFAULT NULL,
ADD COLUMN `bill_address` varchar(40) DEFAULT NULL;
management.tbl_tax_number
创建新表
USE management;
CREATE TABLE `tbl_tax_number` (
`order_id` varchar(11) COLLATE utf8mb4_unicode_ci NOT NULL,
`group_id` int(11) NOT NULL,
`tax_number` int(11) NOT NULL,
`create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`order_id`),
UNIQUE KEY `tax_number_group_id` (`group_id`,`tax_number`)
) ENGINE=InnoDB;
2018-09-13 运行的语句
USE management;
ALTER TABLE `tbl_select_choose` ADD `text_en` VARCHAR(50) NULL DEFAULT NULL AFTER `text`;
-- update tbl_select_choose SET text_en = concat('EEEE', text, 'EEEE'); -- 在测试环境添加了 EEEE
update tbl_select_choose SET text_en = concat('', text, '');
USE management;
ALTER TABLE `tbl_permission_class` ADD `name_en` VARCHAR(50) NULL DEFAULT NULL AFTER `name`;
UPDATE tbl_permission_class SET name_en = concat('', name, '');
USE xnn_core_product_2;
ALTER TABLE `tbl_permission_class` ADD `name_en` VARCHAR(50) NULL DEFAULT NULL AFTER `name`;
UPDATE tbl_permission_class SET name_en = concat('', name, '');
USE management;
ALTER TABLE `tbl_permission` ADD `name_en` VARCHAR(50) NULL DEFAULT NULL AFTER `name`;
USE xnn_core_product_2;
ALTER TABLE `auth_permission` ADD `name_en` VARCHAR(50) NULL DEFAULT NULL AFTER `name`;
USE xnn_core_product_2;
UPDATE `auth_permission` SET `name_en` = (
CASE `id`
WHEN '441' THEN 'Edit Order Remark'
WHEN '91' THEN 'Get Abnormal'
WHEN '89' THEN 'Get Analysis Costofgoods'
WHEN '87' THEN 'Get Analysis Deal'
WHEN '90' THEN 'Get Analysis Orderdetail'
WHEN '88' THEN 'Get Analysis Realdeal'
WHEN '370' THEN 'Get Available Task'
WHEN '85' THEN 'Get Sorting Task'
WHEN '394' THEN 'View Home Page'
WHEN '440' THEN 'View Op Log'
WHEN '103' THEN 'Add Spu'
WHEN '319' THEN 'Delete Public Spu'
WHEN '384' THEN 'Edit Pesticidedetect'
WHEN '104' THEN 'Edit Spu'
WHEN '102' THEN 'Get Spu'
WHEN '64' THEN 'Add Salemenu'
WHEN '66' THEN 'Edit Salemenu'
WHEN '65' THEN 'Get Salemenu'
WHEN '427' THEN 'Add Import Sale Skus'
WHEN '69' THEN 'Add Sku'
WHEN '204' THEN 'Add Sku Batch'
WHEN '323' THEN 'Delete Sale Sku'
WHEN '327' THEN 'Edit Price Timing'
WHEN '68' THEN 'Edit Sku'
WHEN '205' THEN 'Edit Sku Batch'
WHEN '453' THEN 'Edit Smart Pricing'
WHEN '326' THEN 'Get Price Timing'
WHEN '67' THEN 'Get Sku'
WHEN '402' THEN 'Add Pur Spec'
WHEN '398' THEN 'Add Settle Supplier'
WHEN '71' THEN 'Add Supplier'
WHEN '404' THEN 'Delete Pur Spec'
WHEN '400' THEN 'Delete Settle Supplier'
WHEN '403' THEN 'Edit Pur Spec'
WHEN '311' THEN 'Edit Purchase Limit'
WHEN '399' THEN 'Edit Settle Supplier'
WHEN '72' THEN 'Edit Supplier'
WHEN '401' THEN 'Get Pur Spec'
WHEN '312' THEN 'Get Purchase Limit'
WHEN '397' THEN 'Get Settle Supplier'
WHEN '70' THEN 'Get Supplier'
WHEN '74' THEN 'Add Supplier Sku'
WHEN '206' THEN 'Add Supplier Sku Batch'
WHEN '325' THEN 'Delete Supplier Sku'
WHEN '75' THEN 'Edit Supplier Sku'
WHEN '207' THEN 'Edit Supplier Sku Batch'
WHEN '73' THEN 'Get Supplier Sku'
WHEN '77' THEN 'Edit Sku Stocks'
WHEN '395' THEN 'Edit Stock Threshold'
WHEN '76' THEN 'Get Sku Stocks'
WHEN '396' THEN 'Get Stock Threshold Warning'
WHEN '443' THEN 'Get Stock Value'
WHEN '434' THEN 'Add Promotion'
WHEN '433' THEN 'Delete Promotion'
WHEN '432' THEN 'Edit Promotion'
WHEN '79' THEN 'Edit Sale Category'
WHEN '431' THEN 'Get Promotion'
WHEN '78' THEN 'Get Sale Category'
WHEN '386' THEN 'Add Batch Remark'
WHEN '110' THEN 'Add Batchorder'
WHEN '387' THEN 'Add Batchorders'
WHEN '82' THEN 'Add Order'
WHEN '83' THEN 'Delete Order'
WHEN '342' THEN 'Edit Old Order'
WHEN '419' THEN 'Edit Old Order Change'
WHEN '81' THEN 'Edit Order'
WHEN '318' THEN 'Edit Order Status'
WHEN '307' THEN 'Edit Product Unit Price'
WHEN '426' THEN 'Edit Real Quantity'
WHEN '80' THEN 'Get Order'
WHEN '444' THEN 'Get Sku Price Auto'
WHEN '445' THEN 'Get Sku Price Manual'
WHEN '442' THEN 'View Kingdee Import'
WHEN '383' THEN 'View Pesticidedetect'
WHEN '373' THEN 'Add Purchase Task Item'
WHEN '375' THEN 'Delete Purchase Task Item'
WHEN '374' THEN 'Edit Purchase Task Item'
WHEN '372' THEN 'Edit Purchase Task Release'
WHEN '393' THEN 'Get Purchase Dimensional'
WHEN '381' THEN 'Get Purchase History'
WHEN '435' THEN 'Get Purchase Market'
WHEN '317' THEN 'Get Purchase Sheet Export'
WHEN '84' THEN 'Get Purchase Task'
WHEN '382' THEN 'Get Purchase Task Item'
WHEN '451' THEN 'Get Purchase Task Share'
WHEN '308' THEN 'Get Profit Base'
WHEN '309' THEN 'Get Profit Cost'
WHEN '106' THEN 'Add Spu Private'
WHEN '324' THEN 'Delete Private Spu'
WHEN '107' THEN 'Edit Spu Private'
WHEN '105' THEN 'Get Spu Private'
WHEN '109' THEN 'Edit SpuDispatchSetting'
WHEN '108' THEN 'Get SpuDispatchSetting'
WHEN '202' THEN 'Edit Sjgz'
WHEN '203' THEN 'Get Sjgz'
WHEN '209' THEN 'Edit Freight'
WHEN '208' THEN 'Get Freight'
WHEN '343' THEN 'Add Presale Service Time'
WHEN '305' THEN 'Add Service Time'
WHEN '344' THEN 'Edit Presale Service Time'
WHEN '306' THEN 'Edit Service Time'
WHEN '320' THEN 'Add Category'
WHEN '321' THEN 'Delete Category'
WHEN '322' THEN 'Edit Category'
WHEN '347' THEN 'Edit Merchandise Order'
WHEN '329' THEN 'Add In Stock'
WHEN '331' THEN 'Delete In Stock'
WHEN '330' THEN 'Edit In Stock'
WHEN '328' THEN 'Get In Stock'
WHEN '405' THEN 'Import In Stock'
WHEN '333' THEN 'Add Out Stock'
WHEN '334' THEN 'Delete Out Stock'
WHEN '388' THEN 'Edit Outstock Batch'
WHEN '332' THEN 'Get Out Stock'
WHEN '336' THEN 'Add Return Stock'
WHEN '338' THEN 'Delete Return Stock'
WHEN '337' THEN 'Edit Return Stock'
WHEN '335' THEN 'Get Return Stock'
WHEN '406' THEN 'Import Return Stock'
WHEN '340' THEN 'Edit In Return Review'
WHEN '341' THEN 'Edit Operate Settle Sheet'
WHEN '339' THEN 'Get Settle Sheet'
WHEN '367' THEN 'Add Requisition'
WHEN '352' THEN 'Add Return'
WHEN '350' THEN 'Delete Requisition'
WHEN '354' THEN 'Delete Return'
WHEN '349' THEN 'Edit Requisition'
WHEN '353' THEN 'Edit Return'
WHEN '348' THEN 'Get Requisition'
WHEN '351' THEN 'Get Return'
WHEN '356' THEN 'Edit Weigh'
WHEN '355' THEN 'Get Weigh'
WHEN '357' THEN 'Get Weigh Detail'
WHEN '358' THEN 'Add Material'
WHEN '360' THEN 'Add Product'
WHEN '362' THEN 'Delete Material'
WHEN '363' THEN 'Delete Product'
WHEN '359' THEN 'Edit Material'
WHEN '361' THEN 'Edit Product'
WHEN '364' THEN 'Get Requisition Stat'
WHEN '365' THEN 'Get Weigh Stat'
WHEN '366' THEN 'Add Weigh'
WHEN '313' THEN 'Add Purchase Sheet'
WHEN '314' THEN 'Edit Purchase Sheet'
WHEN '315' THEN 'Edit To Instock Sheet'
WHEN '316' THEN 'Get Purchase Sheet'
WHEN '452' THEN 'Get Purchase Sheet Share'
WHEN '377' THEN 'Add Purchaser'
WHEN '379' THEN 'Delete Purchaser'
WHEN '346' THEN 'Edit Purchaser'
WHEN '376' THEN 'Get Purchaser'
WHEN '345' THEN 'Get Purchaser Extra'
WHEN '407' THEN 'Add Shelf'
WHEN '409' THEN 'Delete Shelf'
WHEN '408' THEN 'Edit Shelf'
WHEN '410' THEN 'Get Shelf'
WHEN '439' THEN 'Add Distribute Config'
WHEN '438' THEN 'Delete Distribute Config'
WHEN '413' THEN 'Edit Distribute Config'
WHEN '447' THEN 'Add Address Route'
WHEN '449' THEN 'Delete Address Route'
WHEN '428' THEN 'Distribution Order Edit'
WHEN '430' THEN 'Distribution Order Export'
WHEN '429' THEN 'Distribution Order Search'
WHEN '448' THEN 'Edit Address Route'
WHEN '310' THEN 'Get Distribute Center'
WHEN '411' THEN 'Get Distribute Print'
WHEN '86' THEN 'Get Distribute Task'
WHEN '417' THEN 'Print Driver Tasks'
WHEN '414' THEN 'Get Check Batch Number'
WHEN '415' THEN 'Get Check Shelf Location'
WHEN '416' THEN 'Get Check Spu'
WHEN '418' THEN 'Edit Default Settle Way'
WHEN '454' THEN 'Edit Suggest Price'
WHEN '425' THEN 'Edit Food Security Display'
WHEN '424' THEN 'Get Food Security'
WHEN '389' THEN 'Add Security Report'
WHEN '390' THEN 'Delete Security Report'
WHEN '391' THEN 'Edit Security Report'
WHEN '392' THEN 'Get Security Report'
WHEN '437' THEN 'Edit Tax'
WHEN '436' THEN 'Get Tax'
WHEN '446' THEN 'Receive Order Remind'
END
);
USE management;
UPDATE `tbl_permission` SET `name_en` = (
CASE `id`
WHEN '1' THEN 'Add Permission'
WHEN '2' THEN 'Change Permission'
WHEN '3' THEN 'Delete Permission'
WHEN '24' THEN 'Export Permission'
WHEN '23' THEN 'View Permission'
WHEN '7' THEN 'Add Region'
WHEN '8' THEN 'Change Region'
WHEN '9' THEN 'Delete Region'
WHEN '26' THEN 'Export Region'
WHEN '25' THEN 'View Region'
WHEN '10' THEN 'Add Department'
WHEN '11' THEN 'Change Department'
WHEN '12' THEN 'Delete Department'
WHEN '19' THEN 'View Department'
WHEN '13' THEN 'Add Role'
WHEN '14' THEN 'Change Role'
WHEN '15' THEN 'Delete Role'
WHEN '27' THEN 'View Role'
WHEN '16' THEN 'Add User'
WHEN '17' THEN 'Change User'
WHEN '18' THEN 'Delete User'
WHEN '29' THEN 'View User'
WHEN '41' THEN 'Add Bookmark'
WHEN '42' THEN 'Change Bookmark'
WHEN '43' THEN 'Delete Bookmark'
WHEN '51' THEN 'Export Bookmark'
WHEN '50' THEN 'View Bookmark'
WHEN '44' THEN 'Add Usersettings'
WHEN '45' THEN 'Change Usersettings'
WHEN '46' THEN 'Delete Usersettings'
WHEN '53' THEN 'Export Usersettings'
WHEN '52' THEN 'View Usersettings'
WHEN '47' THEN 'Add Userwidget'
WHEN '48' THEN 'Change Userwidget'
WHEN '49' THEN 'Delete Userwidget'
WHEN '55' THEN 'Export Userwidget'
WHEN '54' THEN 'View Userwidget'
WHEN '65' THEN 'Add Ticket'
WHEN '68' THEN 'Edit Ticket'
WHEN '66' THEN 'View Ticket'
WHEN '108' THEN 'Export Ticketreport'
WHEN '67' THEN 'View Ticketreport'
WHEN '157' THEN 'Add Customer'
WHEN '149' THEN 'Add Stationsalemenu'
WHEN '158' THEN 'Delete Customer'
WHEN '140' THEN 'Delete Stationsalemenu'
WHEN '176' THEN 'Edit Check Out User'
WHEN '179' THEN 'Edit Credit Limit'
WHEN '72' THEN 'Edit Customerarea'
WHEN '150' THEN 'Edit Customercname'
WHEN '144' THEN 'Edit Customerconsignee'
WHEN '143' THEN 'Edit Customerpassword'
WHEN '136' THEN 'Edit Customerstatus'
WHEN '71' THEN 'Edit Keycustomer'
WHEN '155' THEN 'Edit Paymentname'
WHEN '156' THEN 'Edit Paymenttelephone'
WHEN '70' THEN 'Edit Resname'
WHEN '141' THEN 'Edit Salesemployee'
WHEN '135' THEN 'Edit Settlemethod'
WHEN '172' THEN 'Edit Settleway'
WHEN '142' THEN 'Edit Stationsalemenu'
WHEN '137' THEN 'Edit Whitelist'
WHEN '146' THEN 'Export Customerinfo'
WHEN '159' THEN 'Import Customer'
WHEN '178' THEN 'View Credit Limit'
WHEN '69' THEN 'View Customer'
WHEN '177' THEN 'View Unpass User'
WHEN '107' THEN 'Edit Exception'
WHEN '148' THEN 'Edit Lkexception'
WHEN '106' THEN 'View Exception'
WHEN '147' THEN 'View Lkexception'
WHEN '110' THEN 'Export Customerreport'
WHEN '145' THEN 'Export Reportdetail'
WHEN '109' THEN 'View Customerreport'
WHEN '112' THEN 'Export Customeraccount'
WHEN '111' THEN 'View Customeraccount'
WHEN '113' THEN 'Edit Invitation'
WHEN '114' THEN 'Add Refund'
WHEN '116' THEN 'Edit Refund'
WHEN '115' THEN 'View Refund'
WHEN '173' THEN 'Add Order Refund'
WHEN '166' THEN 'Add Settle Remind'
WHEN '171' THEN 'Edit Orderlock'
WHEN '119' THEN 'Edit Settle'
WHEN '118' THEN 'Export Settle'
WHEN '117' THEN 'View Settle'
WHEN '123' THEN 'Edit Balance'
WHEN '122' THEN 'Export Balance'
WHEN '121' THEN 'View Balance'
WHEN '125' THEN 'Export Receipt'
WHEN '124' THEN 'View Receipt'
WHEN '128' THEN 'Add Chongzhang'
WHEN '129' THEN 'Edit Chongzhang'
WHEN '127' THEN 'Export Chongzhang'
WHEN '126' THEN 'View Chongzhang'
WHEN '132' THEN 'Export Orderlist'
WHEN '131' THEN 'View Orderlist'
WHEN '133' THEN 'Edit Saler'
WHEN '134' THEN 'View Saler'
WHEN '120' THEN 'Add Settleprice'
WHEN '139' THEN 'Export Settleprice'
WHEN '138' THEN 'View Settleprice'
WHEN '152' THEN 'Edit Group'
WHEN '151' THEN 'View Group'
WHEN '154' THEN 'Edit Groupmanager'
WHEN '153' THEN 'View Groupmanager'
WHEN '161' THEN 'Export Saleprofit'
WHEN '160' THEN 'View Saleprofit'
WHEN '163' THEN 'Export Customerorder'
WHEN '162' THEN 'View Customerorder'
WHEN '165' THEN 'Export Orderskus'
WHEN '164' THEN 'View Orderskus'
WHEN '168' THEN 'Export Abnormal Customer Order'
WHEN '167' THEN 'View Abnormal Customer Order'
WHEN '170' THEN 'Export Abnormal Skus'
WHEN '169' THEN 'View Abnormal Skus'
WHEN '180' THEN 'View Tax'
END
);